<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>About using page-by on a document</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
p.whs1 { font-weight:normal; }
ol.whs2 { list-style:decimal; }
p.whs3 { margin-left:80px; }
ul.whs4 { list-style:disc; }
p.whs5 { margin-left:0px; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs5 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying documents and dashboards\nGrouping and sorting data in a document\nUsing page-by on a document\nAbout using page-by on a document");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>About using page-by on a document</h1>
<p>You can use page-by to interactively display groups of data on separate 
 pages of the document. This is useful when a document returns a very large 
 set of data in its results. Analysts can use page-by when viewing the 
 document in 
<a HREF="Interactive_Mode.htm">Interactive Mode</a> or the 
 PDF version of the document. Page-by allows a user to select and dynamically 
 display elements from a grouping field as criteria for analysis. The PDF 
 that results from this selection is called a page of the original document. 
 By allowing the use of different criteria to show information, pages provide 
 an added level of data manipulation and display.</p>
<p>For example, a document displays revenue and profit data and is grouped 
 by region and then year. By default, both region and year are included 
 in the page-by field. Analysts can select a specific region and year from 
 the page-by field, to display the data for the selected region and year 
 combination. You can also see the data for all years for a particular 
 region or all data in the document, regardless of region or year. </p>
<p class="whs1">Page-by is automatically enabled when you 
 use grouping fields as part of your organization of a document&rsquo;s 
 data. You can group data based on attributes, consolidations, and custom 
 groups. You cannot group data based on metrics, so you cannot page by 
 metrics. For steps to use grouping fields in a document, see 
<a href="Grouping_data.htm">Grouping 
 records in a document</a>.</p>
<p>You can export only the current page-by selection or the whole document 
 when you export to Excel or PDF.</p>
<h2>To enable page-by</h2>
<p>If you have used grouping fields to organize data in the document, then 
 by default, page-by is enabled for all grouping fields. For steps to use 
 grouping fields in a document, see 
<a href="Grouping_data.htm">Grouping 
 records in a document</a>.</p>
<p>The steps below show you how to enable page-by on a grouping field if 
 page-by has previously been disabled.</p>
<ol type="1" class="whs2">
	
<li class=p><p>Open the document in Design or Editable Mode. </p></li>
	
<li class=p><p>If the Grouping panel is not displayed, from the <span 
 style="font-weight: bold;"><B>Tools</B></span> menu, select <span style="font-weight: bold;"><B>Grouping</B></span>.</p></li>
	
<li class=p><p>In the Grouping panel, right-click the grouping field 
 on which to disable page-by and select <span style="font-weight: bold;"><B>Grouping 
 Properties</B></span>. The Grouping Properties dialog box opens.</p></li>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>Page-by Mode 
 </B></span>drop-down list, select one of the following options:</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p><span style="font-weight: bold;"><B>Page-By 
 (Single Element Only)</B></span>: Enables page-by for this group, but you 
 cannot display all the elements of the group simultaneously in PDF or 
 HTML View. This option is useful for groups with many elements, when you 
 would not want to display all the elements at one time.</p></li>
	</ul>
</ol>
<p class="whs3"><span style="font-weight: bold;"><B>Note</B></span>: 
 When a document contains multiple groups, this option is unavailable for 
 the group farthest to the right in the Grouping panel.</p>
<ul type="disc" class="whs4">
	<ul type="disc" class="whs4">
		
<li class=p><p class="whs5"><span style="font-weight: bold;"><B>Page-By 
 (Single Element or All)</B></span>: Enables page-by for this group and allows 
 all elements of the group to be displayed simultaneously. </p></li>
	</ul>
</ul>
<ol start="5" type="1" class="whs2">
	
<li class=p><p>Click <span style="font-weight: bold;"><B>Apply </B></span>to 
 apply your selections.</p></li>
</ol>
<h2>To disable page-by</h2>
<h3><span style="font-weight: normal;">By default, page-by is enabled for 
 all the grouping fields in the document. If you disable page-by for a 
 particular grouping field, any fields to the right of it in the Grouping 
 panel are also disabled. You can also enable page-by while preventing 
 the simultaneous display of all the elements, which is useful for grouping 
 fields that have many elements.</span> </h3>
<p>This procedure assumes that the document contains at least one grouping 
 field. For steps, see 
<a href="Grouping_data.htm">Grouping records in 
 a document</a>.</p>
<ol type="1" class="whs2">
	
<li class=p><p>Open the document in Design or Editable Mode. </p></li>
	
<li class=p><p>Right-click a grouping item in the Grouping panel. The 
 Grouping Properties dialog box opens. </p></li>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>Page-by Mode 
 </B></span>drop-down list, select <span style="font-weight: bold;"><B>No Page-By 
 (All Only)</B></span><span>.</span></p></li>
</ol>
<p>When you disable Page-by for a particular grouping field, any grouping 
 fields to the right of it in the Grouping panel are also disabled. </p>
<h3>Related topics</h3>
<ul type="disc" class="whs4">
	
<li class=p><p>
<a HREF="Display_of_group.htm">Turning the All option 
 off for selector items</a></p></li>
	
<li class=p><p>
<a HREF="Grouping_data.htm">Grouping records in a document</a></p></li>
	
<li class=p><p>
<a HREF="Grouping_Properties_dialog_box.htm">Grouping 
 Properties dialog box</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
